Skip to main content

enq: CF - contention

Short Description

Enqueue wait on Control Files.

Additional Information​

An enqueue is a wait for a resource held by another.

enq: CF is seen when a control file read or write is held up.

Control file reads and writes happen any time a database file is opened or closed, at log switch times, for backups, and checkpoints.

How to reduce this wait​

Ensure your control file copies are not competing with each other on the same disc device.

Look for multiple backups starting at the same time.

Oracle Docs - Oracle Enqueue Names

Jonathan Lewis - Control File Waits

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.